[dbo].[OrderSuperProductAttributeLookup]

Property	Value
Row Count	1
Created	10:31:30 AM Tuesday, March 02, 2010
Last Modified	11:40:05 AM Monday, February 20, 2012

Property

Value

Row Count

Created

10:31:30 AM Tuesday, March 02, 2010

Last Modified

11:40:05 AM Monday, February 20, 2012

	Name	Data Type	Max Length (Bytes)
$Cluster Primary Key PK_OrderSuperProductAttributeLookup: OrderProductID\OrderSuperProductAttributeID$	OrderProductID	int	4
$Cluster Primary Key PK_OrderSuperProductAttributeLookup: OrderProductID\OrderSuperProductAttributeID$	OrderSuperProductAttributeID	int	4
	SortOrder	int	4

Name

Data Type

Max Length (Bytes)

Allow Nulls

$Cluster Primary Key PK_OrderSuperProductAttributeLookup: OrderProductID\OrderSuperProductAttributeID$

OrderProductID

int

$Cluster Primary Key PK_OrderSuperProductAttributeLookup: OrderProductID\OrderSuperProductAttributeID$

Foreign Keys FK_OrderSuperProductAttributeLookup_OrderSuperProductAttribute: [dbo].[OrderSuperProductAttribute].OrderSuperProductAttributeID

OrderSuperProductAttributeID

int

SortOrder

int

	Name	Columns	Unique
$Cluster Primary Key PK_OrderSuperProductAttributeLookup: OrderProductID\OrderSuperProductAttributeID$	PK_OrderSuperProductAttributeLookup	OrderProductID, OrderSuperProductAttributeID

Name

Columns

Unique

$Cluster Primary Key PK_OrderSuperProductAttributeLookup: OrderProductID\OrderSuperProductAttributeID$

PK_OrderSuperProductAttributeLookup

OrderProductID, OrderSuperProductAttributeID

Name	Update	Delete	Columns
FK_OrderSuperProductAttributeLookup_OrderProduct	Cascade	Cascade	OrderProductID->[dbo].[OrderProduct].[OrderProductID]
FK_OrderSuperProductAttributeLookup_OrderSuperProductAttribute			OrderSuperProductAttributeID->[dbo].[OrderSuperProductAttribute].[OrderSuperProductAttributeID]

Name

Update

Delete

Columns

FK_OrderSuperProductAttributeLookup_OrderProduct

Cascade

OrderProductID->[dbo].[OrderProduct].[OrderProductID]

FK_OrderSuperProductAttributeLookup_OrderSuperProductAttribute

OrderSuperProductAttributeID->[dbo].[OrderSuperProductAttribute].[OrderSuperProductAttributeID]

SQL Script

CREATE TABLE [dbo].[OrderSuperProductAttributeLookup]
(
[OrderProductID] [int] NOT NULL,
[OrderSuperProductAttributeID] [int] NOT NULL,
[SortOrder] [int] NOT NULL
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[OrderSuperProductAttributeLookup] ADD CONSTRAINT [PK_OrderSuperProductAttributeLookup] PRIMARY KEY CLUSTERED ([OrderProductID], [OrderSuperProductAttributeID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[OrderSuperProductAttributeLookup] ADD CONSTRAINT [FK_OrderSuperProductAttributeLookup_OrderProduct] FOREIGN KEY ([OrderProductID]) REFERENCES [dbo].[OrderProduct] ([OrderProductID]) ON DELETE CASCADE ON UPDATE CASCADE
GO
ALTER TABLE [dbo].[OrderSuperProductAttributeLookup] ADD CONSTRAINT [FK_OrderSuperProductAttributeLookup_OrderSuperProductAttribute] FOREIGN KEY ([OrderSuperProductAttributeID]) REFERENCES [dbo].[OrderSuperProductAttribute] ([OrderSuperProductAttributeID])
GO